2014-12-11 - 16173.100 - Spec - Develop a Universe for EPMs #universe

SPECIFICATIONS

16173.100 - Develop a Universe for EPMs

Requirement Summary

Need to develop a Universe that has all the information contained in the EPMs.

Admin Info

Purpose	Need to develop a Universe for EPMs.
Requested By	Jack Mehltretter
Spec Created By	Praveen G
Spec Created Date	12/11/2014
Spec QA by	Uday Kumar P
Objects	EPM Reports
Document Status	Complete

Estimates

SNo	Activity	Estimation in Hours
1	Research	16
2	Documentation	16
3	Development/ Config	48
4	Unit test in DEV	16
5	Unit test in QUA	10
6	Configuration Issues	54
	TOTAL	160

References

Prior Tickets

None

Documents

EPM - Universe.xlsx

Spec Changes

SNo	Change Details	Requested By	Requested On	Notes if any
1	Add Additional Dimensions & Measures	Mark Harris	12/17/2014	Additional Changes
2	NEC wants to sort Fiscal Period as Ascending or Descending in Explorer	Mark Grzechowiak	03/09/2015	Additional Changes

Functional Requirement

Need to create an EPM universe that we will use to create spaces in the SAP Explorer tool.

12-11-2014 - Email from Mark Grzechowiak - NEC Requested us to develop the below required universe:
1. This Universe should be similar to the EPM queries that had been created previously and be able to display data by Region and Sales Org for the current and previous year as well as use the same logic to group and summarize values at the lowest level (i.e. Top 10 Customers individually and the rest grouped together as “Others:”). Please find the required fields below:
Measures: Shipped, Open, Total (Shipped + Open), Budget, Quantity, Contribution.
Dimensions: Region, Sales Org, Product Hierarchy Level 1, Customer Segment, Customer, License, Silhouette.
2. Due to restrictions in Explorer, we would also like to get an idea of how many cells this Universe will produce (rows * columns). Please provide this information as early in development as possible so that we are able to determine if any changes to design will be required.

12-17-2014 - Email from Mark Harris - NEC Requested us to make the following changes in the EPM universe:
1. You should be connecting from BI Dev to BPP so we can have real data to review.
2. The actuals data for shipped and open should be coming from the COPA Open Contract multiprovider.
3. The plan should be coming from the BPC data.
4. The level of detail should be consolidated as it is in BPC.
5. I’ve attached a document with some more details. Please let me know if you have any questions about this. I would also like to know when you think you can get this universe created.
6. I think it would help if you looked at the BEX query we have in analysis VBPC_MP_Q001. That is a data set very like what I am looking for.
I’m not sure if I gave you a name before, but if I gave you the ZBPC one VZBPC_Q001. That’s NOT the one to use.

Solution Summary

1. Need to create Data connections based on required Multi provider.
2. Need to create Data foundation by using data connections.
3. Need to create Business Layer by using data foundations.
4. Need to develop Information space based on Universe.
5. Need to create Explorer reports based on Information Space.

Test Plan

Test ID	Test Scenario	Expected Results
01	Need to test whether the report data matches with Multiprovider.	Data should be validated successfully.
02	Check if the top 10 is working correctly.	Top 10 should be as per NEC requirement.

Solution Details

1. Need to create Data connections based on required Multi provider.
2. Need to create Data foundation by using data connections.
3. Provide Joins between different Multiproviders.
4. Need to create Business Layer by using data foundations.
5. Need to create Dimensions and Measures at Business Layer.
4. Need to develop Information space based on Universe.
5. Need to create Explorer reports based on Information Space.

Issues

Information space not fetching data due to lack of connection and server side missing configurations.